Data type exceptions
When replicating from one Microsoft Azure SQL Managed Instance to a supported Microsoft SQL Server-based target, source and target data types are identical, with the following exceptions:
| Microsoft Azure SQL Managed Instance Source | Microsoft SQL Server Target |
|---|---|
|
DATETIME |
Supported database versions preceding Microsoft SQL Server 2016: DATETIME Microsoft SQL Server 2016 or later: DATETIME2 |
|
VARCHAR |
VARCHAR (x) (when x=0 or x>8000) else VARCHAR (max) |
|
NVARCHAR (length) |
NVARCHAR (x) (when x=0 or x>8000) else NVARCHAR (max) |
|
VARBINARY |
VARBINARY (x) (when x=0 or x>8000) else VARBINARY (max) |
|
HIERARCHYID |
VARCHAR (x) |
|
TIMESTAMP |
VARBINARY |